Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
MerchandiseHierarchyFunctionID (FK)(PK) | A unique system assigned identifier for the MerchandiseHierarchyFunction | ID_MRHRC_FNC | Identity | integer | MerchandiseHierarchyLevel(CO_MRHRC_LV) |
ParentMerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP_PRNT | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
ChildMerchandiseHierarchyGroupID (FK)(PK) | Unique system assigned identifier for a group or class of merchandise. | ID_MRHRC_GP_CHLD | Identity | integer | MerchandiseHierarchyGroup(CO_MRHRC_GP) |
ParentMerchandiseHierarchyLevelID (FK)(PK) | A unique system assigned identifier for the Level within the merchandise hierarchy tree. | ID_MRHRC_LV_PRNT | Identity | integer | MerchandiseHierarchyLevel(CO_MRHRC_LV) |
EffectiveDate | The date and time from which the association is applicable. | DC_EF | EffectiveDate | date | |
ExpirationDate | The date and time until which the association is applicable. | DC_EP | ExpirationDate | date | |